Kolumna PersonID tabeli Person

Definicja kolumny PersonID tabeli Person

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna CountryID tabeli Person

Definicja kolumny CountryID tabeli Person

Name

CountryID

Code

CountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RaceID tabeli Person

Definicja kolumny RaceID tabeli Person

Name

RaceID

Code

RaceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Sex tabeli Person

Definicja kolumny Sex tabeli Person

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

PL: Plec
EN: Sex of the person
DE: das Geschlecht


Kolumna IdentityCardTypeID tabeli Person

Definicja kolumny IdentityCardTypeID tabeli Person

Name

IdentityCardTypeID

Code

IdentityCardTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_PersonID tabeli Person

Definicja kolumny Per_PersonID tabeli Person

Name

Per_PersonID

Code

Per_PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EducationID tabeli Person

Definicja kolumny EducationID tabeli Person

Name

EducationID

Code

EducationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MaritalStatusID tabeli Person

Definicja kolumny MaritalStatusID tabeli Person

Name

MaritalStatusID

Code

MaritalStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CitizenshipID tabeli Person

Definicja kolumny CitizenshipID tabeli Person

Name

CitizenshipID

Code

CitizenshipID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FirstName tabeli Person

Definicja kolumny FirstName tabeli Person

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Imie
EN: First Name
DE: der Name


Kolumna MiddleName tabeli Person

Definicja kolumny MiddleName tabeli Person

Name

MiddleName

Code

MiddleName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna LastName tabeli Person

Definicja kolumny LastName tabeli Person

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

PL: Nazwisko
EN: Last name
DE: der Nachname


Kolumna MaidenName tabeli Person

Definicja kolumny MaidenName tabeli Person

Name

MaidenName

Code

MaidenName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna MotherName tabeli Person

Definicja kolumny MotherName tabeli Person

Name

MotherName

Code

MotherName

Data Type

VARCHAR2(96)

Mandatory

No

Comment

 


Kolumna MotherMaidenName tabeli Person

Definicja kolumny MotherMaidenName tabeli Person

Name

MotherMaidenName

Code

MotherMaidenName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FatherName tabeli Person

Definicja kolumny FatherName tabeli Person

Name

FatherName

Code

FatherName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Imie ojca
EN: Father's name
DE: Der Name des Vater


Kolumna Initials tabeli Person

Definicja kolumny Initials tabeli Person

Name

Initials

Code

Initials

Data Type

VARCHAR2(8)

Mandatory

No

Comment

PL: Inicjaly
EN: Initials
DE: die Anfangsbuchstaben


Kolumna NationalIDNo tabeli Person

Definicja kolumny NationalIDNo tabeli Person

Name

NationalIDNo

Code

NationalIDNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Title tabeli Person

Definicja kolumny Title tabeli Person

Name

Title

Code

Title

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Tytul
EN: Title
DE: Der Titel


Kolumna DOB tabeli Person

Definicja kolumny DOB tabeli Person

Name

DOB

Code

DOB

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PlaceOfBirth tabeli Person

Definicja kolumny PlaceOfBirth tabeli Person

Name

PlaceOfBirth

Code

PlaceOfBirth

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Miejsce urodzenia
EN: Place of birth
DE: Der Geburtsort


Kolumna DeadDT tabeli Person

Definicja kolumny DeadDT tabeli Person

Name

DeadDT

Code

DeadDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ShowAsPatient tabeli Person

Definicja kolumny ShowAsPatient tabeli Person

Name

ShowAsPatient

Code

ShowAsPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ParentsNamesOld tabeli Person

Definicja kolumny ParentsNamesOld tabeli Person

Name

ParentsNamesOld

Code

ParentsNamesOld

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna HealthSecurityNo tabeli Person

Definicja kolumny HealthSecurityNo tabeli Person

Name

HealthSecurityNo

Code

HealthSecurityNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PersonalIDNo tabeli Person

Definicja kolumny PersonalIDNo tabeli Person

Name

PersonalIDNo

Code

PersonalIDNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Citizenship tabeli Person

Definicja kolumny Citizenship tabeli Person

Name

Citizenship

Code

Citizenship

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna Profession tabeli Person

Definicja kolumny Profession tabeli Person

Name

Profession

Code

Profession

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Employer tabeli Person

Definicja kolumny Employer tabeli Person

Name

Employer

Code

Employer

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Comments tabeli Person

Definicja kolumny Comments tabeli Person

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna VIP tabeli Person

Definicja kolumny VIP tabeli Person

Name

VIP

Code

VIP

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli Person

Definicja kolumny InsertDate tabeli Person

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli Person

Definicja kolumny InsertingPerson tabeli Person

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli Person

Definicja kolumny LastModifiedDT tabeli Person

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli Person

Definicja kolumny LastModifiedPerson tabeli Person

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TaxPayerID tabeli Person

Definicja kolumny TaxPayerID tabeli Person

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna MedDataDiscloseRefusal tabeli Person

Definicja kolumny MedDataDiscloseRefusal tabeli Person

Name

MedDataDiscloseRefusal

Code

MedDataDiscloseRefusal

Data Type

NUMBER(5)

Mandatory

No

Comment

Kolumna jest odpowiedzialna za przetrzymywanie flagi 'Zakaz informowania o
pobycie pacjenta'


Kolumna PatientNo tabeli Person

Definicja kolumny PatientNo tabeli Person

Name

PatientNo

Code

PatientNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna PersonDataSource tabeli Person

Definicja kolumny PersonDataSource tabeli Person

Name

PersonDataSource

Code

PersonDataSource

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Zródlo danych na potrzeby raportów do audytu danych osobowych.
.


Kolumna Photo tabeli Person

Definicja kolumny Photo tabeli Person

Name

Photo

Code

Photo

Data Type

BLOB

Mandatory

No

Comment

Zdjecie osoby


Kolumna Dead tabeli Person

Definicja kolumny Dead tabeli Person

Name

Dead

Code

Dead

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Informacja czy pacjent zmarl


Kolumna InsurID tabeli Person

Definicja kolumny InsurID tabeli Person

Name

InsurID

Code

InsurID

Data Type

NUMBER(10)

Mandatory

No

Comment

Wskazuje lokalnego ubezpieczyciela pacjenta, na podstawie jego adresu


Kolumna IsNN tabeli Person

Definicja kolumny IsNN tabeli Person

Name

IsNN

Code

IsNN

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy dodany pacjent zostal dodany jako 'Pacjent NN' czyli pacjent o nieznanej tozsamosci.


Kolumna PersonalIDSeries tabeli Person

Definicja kolumny PersonalIDSeries tabeli Person

Name

PersonalIDSeries

Code

PersonalIDSeries

Data Type

VARCHAR2(8)

Mandatory

No

Comment

Seria dokumentu tozsamosci


Kolumna PersonalIDIssueDate tabeli Person

Definicja kolumny PersonalIDIssueDate tabeli Person

Name

PersonalIDIssueDate

Code

PersonalIDIssueDate

Data Type

DATE

Mandatory

No

Comment

Data wydania dokumentu tozsamosci


Kolumna EmployerPhone tabeli Person

Definicja kolumny EmployerPhone tabeli Person

Name

EmployerPhone

Code

EmployerPhone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Telefon do pracodawcy


Kolumna PersonalIDIssuedBy tabeli Person

Definicja kolumny PersonalIDIssuedBy tabeli Person

Name

PersonalIDIssuedBy

Code

PersonalIDIssuedBy

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Osoba wystawiajaca dokument tozsamosci


Kolumna IsRefugee tabeli Person

Definicja kolumny IsRefugee tabeli Person

Name

IsRefugee

Code

IsRefugee

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy osoba jest uchodzca


Kolumna OriginCountryID tabeli Person

Definicja kolumny OriginCountryID tabeli Person

Name

OriginCountryID

Code

OriginCountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

FK Country.CountryID Id kraju pochodzenia


Kolumna PersonalIDCountryID tabeli Person

Definicja kolumny PersonalIDCountryID tabeli Person

Name

PersonalIDCountryID

Code

PersonalIDCountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

Id kraju wystawiajacego dokument.


Kolumna ParentsNames tabeli Person

Definicja kolumny ParentsNames tabeli Person

Name

ParentsNames

Code

ParentsNames

Data Type

<Undefined>

Mandatory

No

Comment

Imiona rodziców - kolumna wyliczalna as FatherName||' '||MotherName


Kolumna LastName2thPart tabeli Person

Definicja kolumny LastName2thPart tabeli Person

Name

LastName2thPart

Code

LastName2thPart

Data Type

VARCHAR2(60)

Mandatory

No

Comment

kolumna wspomaga wyszukiwanie po drugim czlonie nazwiska


Kolumna Hl7CdaNationalID tabeli Person

Definicja kolumny Hl7CdaNationalID tabeli Person

Name

Hl7CdaNationalID

Code

Hl7CdaNationalID

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Identyfikator krajowy hl7Cda


Kolumna Hl7CdaNationalIDCountryID tabeli Person

Definicja kolumny Hl7CdaNationalIDCountryID tabeli Person

Name

Hl7CdaNationalIDCountryID

Code

Hl7CdaNationalIDCountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kraj wydania identyfikatora


Lista kluczy tabeli Person

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Person

Definicja klucza Identifier_1 tabeli Person

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment